package com.ratp.basedonnees;
/**
 * 
 * @author NK717263
 * classe qui contient toutes les infos (tables, colonnes et listes)
 *
 */
public class BDDinfo {
	public static final int VERSION_BDD = 4;
	public static final String NOM = " expertises_db ";

	public static final class TABLE_EXPERTISES {
		public static final String NOM = " EXPERTISES ";

		public static final class COLONNES {
			public static final class ID {
				public static final String NOM = " ID ";
				public static final int INDEX = 0;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = " PRIMARY KEY AUTOINCREMENT ";
			}

			public static final class ENTREPISE {
				public static final String NOM = " ENTREPISE ";
				public static final int INDEX = 1;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DATE_CONTROLE {
				public static final String NOM = " DATE_CONTROLE ";
				public static final int INDEX = 2;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class NUM_PARC {
				public static final String NOM = " NUM_PARC ";
				public static final int INDEX = 3;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class IMMATRICULATION {
				public static final String NOM = " IMMATRICULATION ";
				public static final int INDEX = 4;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class KM_JOUR_CONT {
				public static final String NOM = " KM_JOUR_CONT ";
				public static final int INDEX = 5;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class MARQUE {
				public static final String NOM = " MARQUE ";
				public static final int INDEX = 6;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class TYPE {
				public static final String NOM = " TYPE ";
				public static final int INDEX = 7;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DATE_MISE_EN_SERVICE {
				public static final String NOM = " DATE_MISE_EN_SERVICE ";
				public static final int INDEX = 8;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class NOTE_GENERALE {
				public static final String NOM = " NOTE_GENERALE ";
				public static final int INDEX = 9;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DIRECTION_E {
				public static final String NOM = " DIRECTION_E ";
				public static final int INDEX = 10;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DIRECTION_EP {
				public static final String NOM = " DIRECTION_EP ";
				public static final int INDEX = 11;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class FREINS_E {
				public static final String NOM = " FREINS_E ";
				public static final int INDEX = 12;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class FREINS_EP {
				public static final String NOM = " FREINS_EP ";
				public static final int INDEX = 13;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class MOTEUR_E {
				public static final String NOM = " MOTEUR_E ";
				public static final int INDEX = 14;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class MOTEUR_EP {
				public static final String NOM = " MOTEUR_EP ";
				public static final int INDEX = 15;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BOITE_VITESSE_E {
				public static final String NOM = " BOITE_VITESSE_E ";
				public static final int INDEX = 16;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BOITE_VITESSE_EP {
				public static final String NOM = " BOITE_VITESSE_EP ";
				public static final int INDEX = 17;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class TRANSMISSION_E {
				public static final String NOM = " TRANSMISSION_E ";
				public static final int INDEX = 18;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class TRANSMISSION_EP {
				public static final String NOM = " TRANSMISSION_EP ";
				public static final int INDEX = 19;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SUSPENSION_E {
				public static final String NOM = " SUSPENSION_E ";
				public static final int INDEX = 20;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SUSPENSION_EP {
				public static final String NOM = " SUSPENSION_EP ";
				public static final int INDEX = 21;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class NOTE_MECANIQUE {
				public static final String NOM = " NOTE_MECANIQUE ";
				public static final int INDEX = 22;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class CIRCUIT_ELECRIQUE_MOTEUR_E {
				public static final String NOM = " CIRCUIT_ELECRIQUE_MOTEUR_E ";
				public static final int INDEX = 23;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class CIRCUIT_ELECRIQUE_MOTEUR_EP {
				public static final String NOM = " CIRCUIT_ELECRIQUE_MOTEUR_EP ";
				public static final int INDEX = 24;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SIGNE_EXTRIEUR_E {
				public static final String NOM = " SIGNE_EXTRIEUR_E ";
				public static final int INDEX = 25;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SIGNE_EXTRIEUR_EP {
				public static final String NOM = " SIGNE_EXTRIEUR_EP ";
				public static final int INDEX = 26;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DIVERS_ELECTRIQUE_E {
				public static final String NOM = " DIVERS_ELECTRIQUE_E ";
				public static final int INDEX = 27;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DIVERS_ELECTRIQUE_EP {
				public static final String NOM = " DIVERS_ELECTRIQUE_EP ";
				public static final int INDEX = 28;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class RAMPE_PMR_E {
				public static final String NOM = " RAMPE_PMR_E ";
				public static final int INDEX = 29;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class RAMPE_PMR_EP {
				public static final String NOM = " RAMPE_PMR_EP ";
				public static final int INDEX = 30;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class NOTE_ELECTRIQUE {
				public static final String NOM = " NOTE_ELECTRIQUE ";
				public static final int INDEX = 31;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class POSTE_CONDUITE_E {
				public static final String NOM = " POSTE_CONDUITE_E ";
				public static final int INDEX = 32;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class POSTE_CONDUITE_EP {
				public static final String NOM = " POSTE_CONDUITE_EP ";
				public static final int INDEX = 33;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SELLERIE_E {
				public static final String NOM = " SELLERIE_E ";
				public static final int INDEX = 34;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class SELLERIE_EP {
				public static final String NOM = " SELLERIE_EP ";
				public static final int INDEX = 35;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class ETAT_INTERIEUR_E {
				public static final String NOM = " ETAT_INTERIEUR_E ";
				public static final int INDEX = 36;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class ETAT_INTERIEUR_EP {
				public static final String NOM = " ETAT_INTERIEUR_EP ";
				public static final int INDEX = 37;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PAREBRISE_E {
				public static final String NOM = " PAREBRISE_E ";
				public static final int INDEX = 38;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PAREBRISE_EP {
				public static final String NOM = " PAREBRISE_EP ";
				public static final int INDEX = 39;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class CARROS_EXT_E {
				public static final String NOM = " CARROS_EXT_E ";
				public static final int INDEX = 40;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class CARROS_EXT_EP {
				public static final String NOM = " CARROS_EXT_EP ";
				public static final int INDEX = 41;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class NOTE_CARROSSERIE {
				public static final String NOM = " NOTE_CARROSSERIE ";
				public static final int INDEX = 42;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_1 {
				public static final String NOM = " PNEUMATIQUE_1 ";
				public static final int INDEX = 43;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_2 {
				public static final String NOM = " PNEUMATIQUE_2 ";
				public static final int INDEX = 44;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_3 {
				public static final String NOM = " PNEUMATIQUE_3 ";
				public static final int INDEX = 45;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_4 {
				public static final String NOM = " PNEUMATIQUE_4 ";
				public static final int INDEX = 46;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_5 {
				public static final String NOM = " PNEUMATIQUE_5 ";
				public static final int INDEX = 47;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class PNEUMATIQUE_6 {
				public static final String NOM = " PNEUMATIQUE_6 ";
				public static final int INDEX = 48;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class CONFORMITE_MONTAGE {
				public static final String NOM = " CONFORMITE_MONTAGE ";
				public static final int INDEX = 49;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class VISITE_DRIRE {
				public static final String NOM = " VISITE_DRIRE ";
				public static final int INDEX = 50;
				public static final String TYPE = " CHAR ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class VISITE_DRIRE_COMMENTAIRE {
				public static final String NOM = " VISITE_DRIRE_COMMENTAIRE ";
				public static final int INDEX = 51;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class VISITE_CONTROLE {
				public static final String NOM = " VISITE_CONTROLE ";
				public static final int INDEX = 52;
				public static final String TYPE = " CHAR ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class VISITE_CONTROLE_COMMENTAIRE {
				public static final String NOM = " VISITE_CONTROLE_COMMENTAIRE ";
				public static final int INDEX = 53;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DECELOMETRE {
				public static final String NOM = " DECELOMETRE ";
				public static final int INDEX = 54;
				public static final String TYPE = " CHAR ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DECELOMETRE_VALEUR {
				public static final String NOM = " DECELOMETRE_VALEUR ";
				public static final int INDEX = 55;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DECELOMETRE_SEC {
				public static final String NOM = " DECELOMETRE_SEC ";
				public static final int INDEX = 56;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class DECELOMETRE_HUMIDE {
				public static final String NOM = " DECELOMETRE_HUMIDE ";
				public static final int INDEX = 57;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BAN_FREINAGE {
				public static final String NOM = " BAN_FREINAGE ";
				public static final int INDEX = 58;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BAN_FREINAGE_VALEUR {
				public static final String NOM = " BAN_FREINAGE_VALEUR ";
				public static final int INDEX = 59;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BAN_FREINAGE_SEC {
				public static final String NOM = " BAN_FREINAGE_SEC ";
				public static final int INDEX = 60;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class BAN_FREINAGE_HUMIDE {
				public static final String NOM = " BAN_FREINAGE_HUMIDE ";
				public static final int INDEX = 61;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = "  ";
			}

			public static final class REMARQUE {
				public static final String NOM = " REMARQUE ";
				public static final int INDEX = 62;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}
		}
		/**
		 * 
		 * @return la liste de toutes les expertises
		 */
		public static final String[] getAllExpertisesColonnes() {
			
			return new String[] {
					 TABLE_EXPERTISES.COLONNES.ID.NOM
					,TABLE_EXPERTISES.COLONNES.ENTREPISE.NOM
					,TABLE_EXPERTISES.COLONNES.DATE_CONTROLE.NOM
					,TABLE_EXPERTISES.COLONNES.NUM_PARC.NOM
					,TABLE_EXPERTISES.COLONNES.IMMATRICULATION.NOM
					,TABLE_EXPERTISES.COLONNES.KM_JOUR_CONT.NOM
					,TABLE_EXPERTISES.COLONNES.MARQUE.NOM
					,TABLE_EXPERTISES.COLONNES.TYPE.NOM
					,TABLE_EXPERTISES.COLONNES.DATE_MISE_EN_SERVICE.NOM
					,TABLE_EXPERTISES.COLONNES.NOTE_GENERALE.NOM
					,TABLE_EXPERTISES.COLONNES.DIRECTION_E.NOM
					,TABLE_EXPERTISES.COLONNES.DIRECTION_EP.NOM
					,TABLE_EXPERTISES.COLONNES.FREINS_E.NOM
					,TABLE_EXPERTISES.COLONNES.FREINS_EP.NOM
					,TABLE_EXPERTISES.COLONNES.MOTEUR_E.NOM
					,TABLE_EXPERTISES.COLONNES.MOTEUR_EP.NOM
					,TABLE_EXPERTISES.COLONNES.BOITE_VITESSE_E.NOM
					,TABLE_EXPERTISES.COLONNES.BOITE_VITESSE_EP.NOM
					,TABLE_EXPERTISES.COLONNES.TRANSMISSION_E.NOM
					,TABLE_EXPERTISES.COLONNES.TRANSMISSION_EP.NOM
					,TABLE_EXPERTISES.COLONNES.SUSPENSION_E.NOM
					,TABLE_EXPERTISES.COLONNES.SUSPENSION_EP.NOM
					,TABLE_EXPERTISES.COLONNES.NOTE_MECANIQUE.NOM
					,TABLE_EXPERTISES.COLONNES.CIRCUIT_ELECRIQUE_MOTEUR_E.NOM
					,TABLE_EXPERTISES.COLONNES.CIRCUIT_ELECRIQUE_MOTEUR_EP.NOM
					,TABLE_EXPERTISES.COLONNES.SIGNE_EXTRIEUR_E.NOM
					,TABLE_EXPERTISES.COLONNES.SIGNE_EXTRIEUR_EP.NOM
					,TABLE_EXPERTISES.COLONNES.DIVERS_ELECTRIQUE_E.NOM
					,TABLE_EXPERTISES.COLONNES.DIVERS_ELECTRIQUE_EP.NOM
					,TABLE_EXPERTISES.COLONNES.RAMPE_PMR_E.NOM
					,TABLE_EXPERTISES.COLONNES.RAMPE_PMR_EP.NOM
					,TABLE_EXPERTISES.COLONNES.NOTE_ELECTRIQUE.NOM
					,TABLE_EXPERTISES.COLONNES.POSTE_CONDUITE_E.NOM
					,TABLE_EXPERTISES.COLONNES.POSTE_CONDUITE_EP.NOM
					,TABLE_EXPERTISES.COLONNES.SELLERIE_E.NOM
					,TABLE_EXPERTISES.COLONNES.SELLERIE_EP.NOM
					,TABLE_EXPERTISES.COLONNES.ETAT_INTERIEUR_E.NOM
					,TABLE_EXPERTISES.COLONNES.ETAT_INTERIEUR_EP.NOM
					,TABLE_EXPERTISES.COLONNES.PAREBRISE_E.NOM
					,TABLE_EXPERTISES.COLONNES.PAREBRISE_EP.NOM
					,TABLE_EXPERTISES.COLONNES.CARROS_EXT_E.NOM
					,TABLE_EXPERTISES.COLONNES.CARROS_EXT_EP.NOM
					,TABLE_EXPERTISES.COLONNES.NOTE_CARROSSERIE.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_1.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_2.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_3.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_4.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_5.NOM
					,TABLE_EXPERTISES.COLONNES.PNEUMATIQUE_6.NOM
					,TABLE_EXPERTISES.COLONNES.CONFORMITE_MONTAGE.NOM
					,TABLE_EXPERTISES.COLONNES.VISITE_DRIRE.NOM
					,TABLE_EXPERTISES.COLONNES.VISITE_DRIRE_COMMENTAIRE.NOM
					,TABLE_EXPERTISES.COLONNES.VISITE_CONTROLE.NOM
					,TABLE_EXPERTISES.COLONNES.VISITE_CONTROLE_COMMENTAIRE.NOM
					,TABLE_EXPERTISES.COLONNES.DECELOMETRE.NOM
					,TABLE_EXPERTISES.COLONNES.DECELOMETRE_VALEUR.NOM
					,TABLE_EXPERTISES.COLONNES.DECELOMETRE_SEC.NOM
					,TABLE_EXPERTISES.COLONNES.DECELOMETRE_HUMIDE.NOM
					,TABLE_EXPERTISES.COLONNES.BAN_FREINAGE.NOM
					,TABLE_EXPERTISES.COLONNES.BAN_FREINAGE_VALEUR.NOM
					,TABLE_EXPERTISES.COLONNES.BAN_FREINAGE_SEC.NOM
					,TABLE_EXPERTISES.COLONNES.BAN_FREINAGE_HUMIDE.NOM
					,TABLE_EXPERTISES.COLONNES.REMARQUE.NOM
			};
		}
	}

	public static final class TABLE_MARQUES {
		public static final String NOM = " MARQUES ";

		public static final class COLONNES {
			public static final class ID {
				public static final String NOM = " ID ";
				public static final int INDEX = 0;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = " PRIMARY KEY AUTOINCREMENT ";
			}

			public static final class MARQUE {
				public static final String NOM = " MARQUE ";
				public static final int INDEX = 1;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}
		}
		public static final String[] getAllMarquesColonnes() {
			return new String[] {
					TABLE_MARQUES.COLONNES.ID.NOM
					,TABLE_MARQUES.COLONNES.MARQUE.NOM
			};
		}
	}
	public static final class TABLE_TYPES {
		public static final String NOM = " TYPES ";

		public static final class COLONNES {
			public static final class ID {
				public static final String NOM = " ID ";
				public static final int INDEX = 0;
				public static final String TYPE = " INTEGER ";
				public static final String CONTRAINTES = " PRIMARY KEY AUTOINCREMENT ";
			}

			public static final class TYPE {
				public static final String NOM = " TYPE ";
				public static final int INDEX = 1;
				public static final String TYPE = " TEXT ";
				public static final String CONTRAINTES = "  ";
			}
		}
	}
	public static final String[] getAllTypesColonnes() {
		return new String[] {
				TABLE_TYPES.COLONNES.ID.NOM
				,TABLE_TYPES.COLONNES.TYPE.NOM
		};
	}
}


